You are here: Main Menu > I. Interface Menu > 7. External System > 3. ESI Item Base Price

ESI Item Base Price

The ESI Item Base Price function exports the base selling prices for each item by sales category or sales categories.

1. Follow the common External System Interface (ESI) overview and instructions found in the ESI menu overview.

2. When you first enter the ESI Item Base Price option a Select An Option window will display the following options:

EXIT – Select EXIT to exit and return to the Interface menu.
ALL – Select ALL to select all sales categories defined in the system.
A list of sales categories from which to choose from.

Scroll to the appropriate selection and press Enter. An asterisk (*) will appear confirming your selection. Select EXIT to continue.

If the file name and type selected already exist, the following message will display: "Warning: File already exists!!! Continue? No/Yes."

Select no to return to the Select An Option window.
Select yes to create a new file with the same name that already exists.

3. The following message will display: "Create a delimited ASC file? No/Yes?"

Select no to create a DBF file only.
Select yes to create a DBF file and an ASC file.

Make the appropriate selection.

The following message will appear: "(File name) file creation completed!!! Space bar to continue." Press the space bar to continue.

Two DBF files will be created BPMMDDYYYY.dbf and BP_Last.dbf in the Shared \NetYield\Data\Company Name\ESI Outbox folder. The BPMMDDYYYY.dbf file is the ESI Item Base Price file for the current date with MMDDYYYY equal to the current date The BP_Last.dbf is a copy of the current file. If a ASC file was selected to be created, the name will be BPMMDDYYYY.asc in the Shared\NetYield\Data\Company Name\ESI Outbox folder.

The following fields will be exported from the system:

Field Name	Description	Type
B_ITEM	The item code	C 8
B_NAME	The item name	C 30
B_PRICEUN	The pricing unit of measure	C 2
B_PRICE1	Base selling price 1, as entered for base price 1 in Set Selling Prices	N 10, 4
B_PRICE2	Base selling price 2	N 10, 4
B_PRICE3	Base selling price 3	N 10, 4
B_PRICE4	Base selling price 4	N 10, 4
B_PRICE5	Base selling price 5	N 10, 4
B_PRICE6	Base selling price 6	N 10, 4
B_PRICE7	Base selling price 7	N 10, 4
B_PRICE8	Base selling price 8	N 10, 4
B_AVAIL	The current available inventory based on the Inventory Availability setup in Sales Options	N 12, 4
B_SCAT	The sales category for the item	C 2

Security Required : Sales - Selling Prices